From b1f57f6cada0e9243b0bd429069a7c916fa09022 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 18 Jul 2026 01:07:39 +0000 Subject: [PATCH] Create, document, index, and trigger ELO_RANKS_DAILY_MT_M --- db/schemas/lib/triggers/Makefile | 3 ++- .../triggers/create/elo_ranks_daily_mt_m.m4 | 27 +++++++++++++++++++ .../lib/triggers/drop/elo_ranks_daily_mt_m.m4 | 24 +++++++++++++++++ db/schemas/sokwedb/indexes/Makefile | 2 +- .../indexes/create/elo_ranks_daily_mt_m.m4 | 24 +++++++++++++++++ .../indexes/drop/elo_ranks_daily_mt_m.m4 | 24 +++++++++++++++++ db/schemas/sokwedb/tables/Makefile | 3 ++- .../tables/create/elo_ranks_daily_mt_m.m4 | 26 ++++++++++++++++++ doc/src/analyzed.m4 | 1 + doc/src/analyzed/elo_ranks_daily_mt_m.m4 | 22 +++++++++++++++ doc/src/epilog.inc.m4 | 3 +++ 11 files changed, 156 insertions(+), 3 deletions(-) create mode 100644 db/schemas/lib/triggers/create/elo_ranks_daily_mt_m.m4 create mode 100644 db/schemas/lib/triggers/drop/elo_ranks_daily_mt_m.m4 create mode 100644 db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_m.m4 create mode 100644 db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_m.m4 create mode 100644 db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_m.m4 create mode 100644 doc/src/analyzed/elo_ranks_daily_mt_m.m4 diff --git a/db/schemas/lib/triggers/Makefile b/db/schemas/lib/triggers/Makefile index e7bfab3..ac07f63 100644 --- a/db/schemas/lib/triggers/Makefile +++ b/db/schemas/lib/triggers/Makefile @@ -54,7 +54,8 @@ ORDER := comm_ids \ matings \ elo_ranks_daily_kk_f \ elo_ranks_daily_kk_m \ - elo_ranks_daily_mt_f + elo_ranks_daily_mt_f \ + elo_ranks_daily_mt_m DROP_EXISTING := true diff --git a/db/schemas/lib/triggers/create/elo_ranks_daily_mt_m.m4 b/db/schemas/lib/triggers/create/elo_ranks_daily_mt_m.m4 new file mode 100644 index 0000000..2166614 --- /dev/null +++ b/db/schemas/lib/triggers/create/elo_ranks_daily_mt_m.m4 @@ -0,0 +1,27 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc. http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify it +dnl under the terms of the GNU Affero General Public License as published by +dnl the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Triggers for the elo_ranks_daily_mt_m table +dnl +dnl Karl O. Pinc + +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`macros.m4')dnl +include(`elo_ranks_daily_triggers_create.m4')dnl + + +elo_ranks_daily_triggers_create(`male', sdb_male, `MT') diff --git a/db/schemas/lib/triggers/drop/elo_ranks_daily_mt_m.m4 b/db/schemas/lib/triggers/drop/elo_ranks_daily_mt_m.m4 new file mode 100644 index 0000000..c520789 --- /dev/null +++ b/db/schemas/lib/triggers/drop/elo_ranks_daily_mt_m.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc. http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published by +dnl the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Drop triggers for elo_ranks_daily_mt_m table +dnl +dnl Karl O. Pinc + +dnl m4 includes +include(`copyright.m4')dnl +include(`elo_ranks_daily_triggers_drop.m4')dnl + +elo_ranks_daily_triggers_drop(sdb_male, `MT') diff --git a/db/schemas/sokwedb/indexes/Makefile b/db/schemas/sokwedb/indexes/Makefile index b1b0dd1..4cc41ad 100644 --- a/db/schemas/sokwedb/indexes/Makefile +++ b/db/schemas/sokwedb/indexes/Makefile @@ -25,7 +25,7 @@ ORDER := biography_data biography_log comm_membs comm_memb_log \ aggressions food_events groomings attendance \ arrivals_a species_present repro_states locations_utm \ locations_paper colobus matings fertility elo_ranks_daily_kk_f \ - elo_ranks_daily_kk_m elo_ranks_daily_mt_f + elo_ranks_daily_kk_m elo_ranks_daily_mt_f elo_ranks_daily_mt_m ## ## CAUTION: This Makefile is not designed to be run directly. It is normally diff --git a/db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_m.m4 b/db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_m.m4 new file mode 100644 index 0000000..4d99353 --- /dev/null +++ b/db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_m.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`indexmacros.m4')dnl + +elo_ranks_daily_indexes_create(sdb_male, `MT') diff --git a/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_m.m4 b/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_m.m4 new file mode 100644 index 0000000..043c105 --- /dev/null +++ b/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_m.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`indexmacros.m4')dnl + +elo_ranks_daily_indexes_drop(sdb_male, `MT') diff --git a/db/schemas/sokwedb/tables/Makefile b/db/schemas/sokwedb/tables/Makefile index 6ed2b1e..4316652 100644 --- a/db/schemas/sokwedb/tables/Makefile +++ b/db/schemas/sokwedb/tables/Makefile @@ -53,7 +53,8 @@ ORDER := biography_data \ fertility \ elo_ranks_daily_kk_f \ elo_ranks_daily_kk_m \ - elo_ranks_daily_mt_f + elo_ranks_daily_mt_f \ + elo_ranks_daily_mt_m ## ## CAUTION: This Makefile is not designed to be run directly. It is normally diff --git a/db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_m.m4 b/db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_m.m4 new file mode 100644 index 0000000..7ce0804 --- /dev/null +++ b/db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_m.m4 @@ -0,0 +1,26 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`tablemacros.m4')dnl +include(`grants.m4')dnl +dnl + +elo_ranks_daily_table(sdb_male, `MT') diff --git a/doc/src/analyzed.m4 b/doc/src/analyzed.m4 index b9a1f80..77c210e 100644 --- a/doc/src/analyzed.m4 +++ b/doc/src/analyzed.m4 @@ -34,6 +34,7 @@ a rudimentary analytical process. analyzed/elo_ranks_daily_kk_f.rst analyzed/elo_ranks_daily_kk_m.rst analyzed/elo_ranks_daily_mt_f.rst + analyzed/elo_ranks_daily_mt_m.rst analyzed/fertility.rst analyzed/repro_states.rst analyzed/swelling_states.rst diff --git a/doc/src/analyzed/elo_ranks_daily_mt_m.m4 b/doc/src/analyzed/elo_ranks_daily_mt_m.m4 new file mode 100644 index 0000000..3298534 --- /dev/null +++ b/doc/src/analyzed/elo_ranks_daily_mt_m.m4 @@ -0,0 +1,22 @@ +.. Copyright (C) 2026 The Meme Factory, Inc. www.karlpinc.com + + This program is free software: you can redistribute it and/or modify + it under the terms of the GNU Affero General Public License as + published by the Free Software Foundation, either version 3 of the + License, or (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU Affero General Public License for more details. + + You should have received a copy of the GNU Affero General Public License + along with this program. If not, see . + +.. M4 setup +include(constants.m4)dnl +include(macros.m4)dnl +include(elo_ranks_daily_macro.m4)dnl +sdb_generated_rst()dnl + +elo_ranks_daily_macro(male, sdb_male, MT) diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4 index 46b72ed..c22a8ef 100644 --- a/doc/src/epilog.inc.m4 +++ b/doc/src/epilog.inc.m4 @@ -402,6 +402,9 @@ elo_ranks_daily_rst(sdb_male, KK)dnl .. ELO_RANKS_DAILY_MT_F elo_ranks_daily_rst(sdb_female, MT)dnl +.. ELO_RANKS_DAILY_MT_M +elo_ranks_daily_rst(sdb_male, MT)dnl + .. |ENTRYTYPES| replace:: :ref:`ENTRYTYPES ` .. |ENTRYTYPES.EntryType| replace:: :ref:`EntryType ` -- 2.34.1